<?php

class UsersController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
            array(
                'application.filters.RequireLoginFilter',
            ),
        );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {

        return array(
            array('allow', // allow all users to perform 'index' and 'view' actions

                'users' => array('*'),
            ),
            array('deny', // deny all users
                'users' => array('*'),
            ),
        );
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new Users;
        $model->setScenario('register');
        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);        
        if (isset($_POST['Users'])) {
            $model->attributes = $_POST['Users'];
             if(isset($_POST['customerName']))
             {
                $customerModel = Customers::model()->findByPk($model->custno);
                if($customerModel!=NULL)
                {
                    if(strpos($_POST['customerName'],'-')!==FALSE)
                    {
                        $strArr = explode('-', $_POST['customerName']);
                        $_POST['customerName'] = $strArr[1];
                    }
              
                    if(trim($_POST['customerName'])!=trim($customerModel->lastname))
                    {
                        $model->custno = "";
                    }
                }
             }
            if(isset($_POST['employeeName'])&&$model->employee){
                if($_POST['employeeName']!==($model->employee->firstname.' '.$model->employee->lastname))
                {
                    $model->employeeid = "";                    
                }
             }
             if (isset($_POST['Users']['privileges'])) {
                $data = array_values($_POST['Users']['privileges']);

                $model->privileges = serialize($data);
            }
            if ($model->save())
                $this->redirect(array('index'));
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);
        if(isset($model->userAccess->type))
        $model->utype = $model->userAccess->type;
        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Users'])) {

            $model->attributes = $_POST['Users'];
            if(isset($_POST['customerName']))
             {
                $customerModel = Customers::model()->findByPk($model->custno);
                if($customerModel!=NULL)
                {
                    if(strpos($_POST['customerName'],'-')!==FALSE)
                    {
                        $strArr = explode('-', $_POST['customerName']);
                        $_POST['customerName'] = $strArr[1];
                    }
              
                    if(trim($_POST['customerName'])!=trim($customerModel->lastname))
                    {
                        $model->custno = "";
                    }
                }
             }
             if(isset($_POST['employeeName'])&&$model->employee){
                if($_POST['employeeName']!==($model->employee->firstname.' '.$model->employee->lastname))
                {
                    $model->employeeid = "";
                }
             }
            if (isset($_POST['Users']['privileges'])) {
                $data = array_values($_POST['Users']['privileges']);
                
                $model->privileges = serialize($data);
            }

            if ($model->save())
                $this->redirect(array('index', 'id' => $model->id));
        }
        $model->password = '';
        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {

        // we only allow deletion via POST request
        $this->loadModel($id)->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (!isset($_GET['ajax']))
            $this->redirect(array('index'));
    }

    /**
     * Lists all models.
     */
    public function actionIndex() {


        $dataProvider = new CActiveDataProvider('Users');
        $this->render('index', array(
            'dataProvider' => $dataProvider,
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new Users('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['Users']))
            $model->attributes = $_GET['Users'];

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id) {
        $model = Users::model()->findByPk($id);

        $model->setScenario('register');
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'users-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

     public function actionUserList($query=NULL, $page=1, $limit=25,$sort=NULL, $dir=NULL,$type=NULL) {
        //we decrease $page by 1 because in Extjs first page is 1, but in our sql first page is 0;
        if ($page > 0)
            $page--;

        $criteria = new CDbCriteria();
        $order = CJSON::decode($sort);
        if ($sort != NULL) {
            $criteria->order = $order[0]['property'] . ' ' . $order[0]['direction'];
        }
        $data = new CActiveDataProvider('Users', array(
                    'criteria' => $criteria,
                    'pagination' => array(
                        'currentPage' => $page,
                        'pageSize' => $limit,
                    )
                ));
        $rs = array();
$criteria->compare('LOWER(real_name)',strtolower($query),true); 

	     switch($type){
		     case 'C': $criteria->compare('custno','<> ');
			     break;
		     case 'E':$criteria->compare('employeeid','<> ');
			     break;
		     case 'NR':$criteria->compare('custno','<> ');
			           $criteria->compare('employeeid','<> ');
			     break;
	     }
        if (count($data->getData()) > 0) {
            $rs['totalCount'] = $data->getTotalItemCount();
            foreach ($data->getData() as $i => $item) {
	                
                $rs['data'][] = array(
                    'id' => $item->id,
                    'real_name' => $item->real_name,
                    'email' => $item->email,
                    'created_date' => $item->created_date,
                    'employeeid' => $item->employeeid,
                    'custno' => $item->custno,
                    'deviceid' => $item->deviceid,
                );
            }

            echo json_encode($rs);
        }
        Yii::app()->end();
    }

}

